Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
ItemDateTypeCode (FK)(PK) | Three/four character lookup code | TY_DT_ITM | Code4 | CHAR(4) | ItemDateType(LY_ITM_DT_TY) |
ItemTraceableUnitID (FK)(PK) | A universally unique identifier used to identify an instance of a distinguisable instance of a retail item. The item traceable unit ID is similar to a serial number in that it allows each selling unit to be explicitly identified and distinguished from other sellling units of the same Item. | ID_ITM_UN_TRC | IdentityUUID | CHAR(32) | ItemTraceableUnit(AS_ITM_TRCBL_UN) |
DateTime | A date (and optionall a time) for a specific item's date type. For example, an item might have a Packaged Date of 27 June 2009 or a Best Before Date of 27 June 2009 12 noon. | TS_ITM_UN | AuditDateTime | datetime | |